Cannot edit formulas in data entry form due to design.

Cause:


This is by design of Microsoft Excel.

Solution:


Edit formulas in the worksheet.